IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_bulletin]') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_bulletin
(
    Id INT IDENTITY(1,1) NOT NULL,
    EnterpriseName varchar(200) not null,
    Zhanwei varchar(200) null,
    Address varchar(500) not null,
    Phone varchar(40) not null default(''),
    FaxNumber varchar(20) not null default(''),
    Email varchar(200) null,
    homepage varchar(255) null,
    ShowContent varchar(1000) not null,
    EnterpriseIntroduction varchar(1000) not null,
    
	
    CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_bullet_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO